package com.guangyuan.network.dao.interfaces.sql;

public interface ProductSql {
	public String insert = "insert into product(name, cn_name, description, gmt_create, gmt_modified, operator, product_group_id, imglink) values(?, ?, ?, current_timestamp, current_timestamp, ?, ?, ?)";
	public String update = "update product set name=?, cn_name=?, description=?, gmt_modified=current_timestamp, operator=?, imglink=? where id=?";
	public String selectByProductGroupId = "select id, name, cn_name, description, gmt_create, gmt_modified, operator, product_group_id, imglink from product where product_group_id=? limit ?, ?";
	public String delete = "delete from product where id=?";
	public String getProduct = "select id, name, cn_name, description, gmt_create, gmt_modified, operator, product_group_id, imglink from product where id=?";
}
